<CFQUERY name="getstatus" datasource="#application.dsn#">
SELECT * FROM status
</CFQUERY>
<FORM action="/codesaver/index.cfm" method="post">
	<SELECT name="status" size="1">
	<OPTION value="0"> Select status
	<CFOUTPUT query="getstatus">
	<OPTION value="#statusid#">#status#</OPTION>
	</CFOUTPUT>
	</SELECT>
</FORM>
